<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<title>i2c: dbCategory Class Reference</title>

<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="doxygen.css" rel="stylesheet" type="text/css" />

<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
  $(document).ready(function() { searchBox.OnSelectItem(0); });
</script>

</head>
<body>
<div id="top"><!-- do not remove this div! -->


<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  
  
  <td style="padding-left: 0.5em;">
   <div id="projectname">i2c
   
   </div>
   
  </td>
  
  
  
 </tr>
 </tbody>
</table>
</div>

<!-- Generated by Doxygen 1.7.5.1 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="pages.html"><span>Related&#160;Pages</span></a></li>
      <li class="current"><a href="annotated.html"><span>Data&#160;Structures</span></a></li>
      <li><a href="files.html"><span>Files</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="Search" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
          </span>
        </div>
      </li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="annotated.html"><span>Data&#160;Structures</span></a></li>
      <li><a href="classes.html"><span>Data&#160;Structure&#160;Index</span></a></li>
      <li><a href="functions.html"><span>Data&#160;Fields</span></a></li>
    </ul>
  </div>
</div>
<div class="header">
  <div class="summary">
<a href="#pub-methods">Public Member Functions</a> &#124;
<a href="#pub-static-methods">Static Public Member Functions</a>  </div>
  <div class="headertitle">
<div class="title">dbCategory Class Reference</div>  </div>
</div>
<div class="contents">
<!-- doxytag: class="dbCategory" --><table class="memberdecls">
<tr><td colspan="2"><h2><a name="pub-methods"></a>
Public Member Functions</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classdb_category.html#a772b8c55b241668e6031bb263f5d832f">getAllCategories</a> ()</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classdb_category.html#a86e23bd1f4d5b3b616ea11b6ac2d1c8c">checkCategoryID</a> ($c)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classdb_category.html#a7fc3d9a38dbf98b9cce2961e298a9a86">getCategoryID</a> ($c)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classdb_category.html#af9a3ee1cae55fca49cdd6f9cc325a011">getCategoryName</a> ($c)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classdb_category.html#a9287137c4ed5d2383f8e098d7d8ce286">deleteCategoryID</a> ($c)</td></tr>
<tr><td colspan="2"><h2><a name="pub-static-methods"></a>
Static Public Member Functions</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classdb_category.html#aea6c4d653e217f31256ded5783ed58f4">createTable</a> ()</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classdb_category.html#a4fb22ba86a2ad867f7e5ecd1b62e265f">addCategory</a> ($c, &amp;$id)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classdb_category.html#aaaca33ac319178544c7cc9df0d9f1578">getAllByID</a> ($id, &amp;$output)</td></tr>
</table>
<hr/><a name="details" id="details"></a><h2>Detailed Description</h2>
<div class="textblock"><p>Communicates with the <a class="el" href="class_student.html">Student</a> control file to know which student data to get and set. It is the only file that has the SQL queries and MySQL connections</p>
<dl class="copyright"><dt><b>Copyright:</b></dt><dd>2011 by Dan, Steven, Brice, Mike, and Aaron. This program is part of <a class="el" href="class_internship.html">Internship</a> 2 Career, which is free software. It comes with absolutely no warranty. You can redistribute or modify it under the terms of the GNU General Public License as published by the Free Software Foundation (For more information, see &lt;<a href="http://www.gnu.org/licenses/">http://www.gnu.org/licenses/</a>).</dd></dl>
<dl class="version"><dt><b>Version:</b></dt><dd>February 8, 2011</dd></dl>
<dl class="author"><dt><b>Author:</b></dt><dd>Brice Rader and Aaron Jarzombeck This is the database file. It controls the category file to list all categories and to add or delete a category into the database. It is the only file that has the SQL queries and MySQL connections </dd></dl>

<p>Definition at line <a class="el" href="db_category_8php_source.html#l00025">25</a> of file <a class="el" href="db_category_8php_source.html">dbCategory.php</a>.</p>
</div><hr/><h2>Member Function Documentation</h2>
<a class="anchor" id="a4fb22ba86a2ad867f7e5ecd1b62e265f"></a><!-- doxytag: member="dbCategory::addCategory" ref="a4fb22ba86a2ad867f7e5ecd1b62e265f" args="($c, &amp;$id)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static addCategory </td>
          <td>(</td>
          <td class="paramtype">$&#160;</td>
          <td class="paramname"><em>c</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">&amp;$&#160;</td>
          <td class="paramname"><em>id</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>Add's a category to the database </p>
<dl><dt><b>Parameters:</b></dt><dd>
  <table class="params">
    <tr><td class="paramtype">category</td><td class="paramname">$c</td><td></td></tr>
    <tr><td class="paramtype">category</td><td class="paramname">$id</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>Returns:</b></dt><dd>new category added to database </dd></dl>

<p>Definition at line <a class="el" href="db_category_8php_source.html#l00073">73</a> of file <a class="el" href="db_category_8php_source.html">dbCategory.php</a>.</p>

</div>
</div>
<a class="anchor" id="a86e23bd1f4d5b3b616ea11b6ac2d1c8c"></a><!-- doxytag: member="dbCategory::checkCategoryID" ref="a86e23bd1f4d5b3b616ea11b6ac2d1c8c" args="($c)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">checkCategoryID </td>
          <td>(</td>
          <td class="paramtype">$&#160;</td>
          <td class="paramname"><em>c</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>Checks category ID </p>
<dl><dt><b>Parameters:</b></dt><dd>
  <table class="params">
    <tr><td class="paramtype">contact</td><td class="paramname">$c</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>Returns:</b></dt><dd>checks to see what contacts are in the database </dd></dl>

<p>Definition at line <a class="el" href="db_category_8php_source.html#l00101">101</a> of file <a class="el" href="db_category_8php_source.html">dbCategory.php</a>.</p>

</div>
</div>
<a class="anchor" id="aea6c4d653e217f31256ded5783ed58f4"></a><!-- doxytag: member="dbCategory::createTable" ref="aea6c4d653e217f31256ded5783ed58f4" args="()" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static createTable </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>Definition at line <a class="el" href="db_category_8php_source.html#l00027">27</a> of file <a class="el" href="db_category_8php_source.html">dbCategory.php</a>.</p>

</div>
</div>
<a class="anchor" id="a9287137c4ed5d2383f8e098d7d8ce286"></a><!-- doxytag: member="dbCategory::deleteCategoryID" ref="a9287137c4ed5d2383f8e098d7d8ce286" args="($c)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">deleteCategoryID </td>
          <td>(</td>
          <td class="paramtype">$&#160;</td>
          <td class="paramname"><em>c</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>Delete's category from database </p>
<dl><dt><b>Parameters:</b></dt><dd>
  <table class="params">
    <tr><td class="paramtype">contact</td><td class="paramname">$c</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>Returns:</b></dt><dd>categories in database </dd></dl>

<p>Definition at line <a class="el" href="db_category_8php_source.html#l00152">152</a> of file <a class="el" href="db_category_8php_source.html">dbCategory.php</a>.</p>

</div>
</div>
<a class="anchor" id="aaaca33ac319178544c7cc9df0d9f1578"></a><!-- doxytag: member="dbCategory::getAllByID" ref="aaaca33ac319178544c7cc9df0d9f1578" args="($id, &amp;$output)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static getAllByID </td>
          <td>(</td>
          <td class="paramtype">$&#160;</td>
          <td class="paramname"><em>id</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">&amp;$&#160;</td>
          <td class="paramname"><em>output</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<dl><dt><b>Parameters:</b></dt><dd>
  <table class="params">
    <tr><td class="paramtype">contact</td><td class="paramname">$id</td><td></td></tr>
  </table>
  </dd>
</dl>

<p>Definition at line <a class="el" href="db_category_8php_source.html#l00176">176</a> of file <a class="el" href="db_category_8php_source.html">dbCategory.php</a>.</p>

</div>
</div>
<a class="anchor" id="a772b8c55b241668e6031bb263f5d832f"></a><!-- doxytag: member="dbCategory::getAllCategories" ref="a772b8c55b241668e6031bb263f5d832f" args="()" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">getAllCategories </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>Gets all of the categories in the database </p>
<dl class="return"><dt><b>Returns:</b></dt><dd>categories </dd></dl>

<p>Definition at line <a class="el" href="db_category_8php_source.html#l00052">52</a> of file <a class="el" href="db_category_8php_source.html">dbCategory.php</a>.</p>

</div>
</div>
<a class="anchor" id="a7fc3d9a38dbf98b9cce2961e298a9a86"></a><!-- doxytag: member="dbCategory::getCategoryID" ref="a7fc3d9a38dbf98b9cce2961e298a9a86" args="($c)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">getCategoryID </td>
          <td>(</td>
          <td class="paramtype">$&#160;</td>
          <td class="paramname"><em>c</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>Get category ID from the database </p>
<dl><dt><b>Parameters:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">$categoryID</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>Returns:</b></dt><dd>ID </dd></dl>

<p>Definition at line <a class="el" href="db_category_8php_source.html#l00122">122</a> of file <a class="el" href="db_category_8php_source.html">dbCategory.php</a>.</p>

</div>
</div>
<a class="anchor" id="af9a3ee1cae55fca49cdd6f9cc325a011"></a><!-- doxytag: member="dbCategory::getCategoryName" ref="af9a3ee1cae55fca49cdd6f9cc325a011" args="($c)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">getCategoryName </td>
          <td>(</td>
          <td class="paramtype">$&#160;</td>
          <td class="paramname"><em>c</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div>
<div class="memdoc">
<p>Get category name from the database </p>
<dl><dt><b>Parameters:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">$CategoryName</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>Returns:</b></dt><dd><a class="el" href="class_category.html">Category</a> </dd></dl>

<p>Definition at line <a class="el" href="db_category_8php_source.html#l00134">134</a> of file <a class="el" href="db_category_8php_source.html">dbCategory.php</a>.</p>

</div>
</div>
<hr/>The documentation for this class was generated from the following file:<ul>
<li>C:/Users/Jon/Downloads/OOP/db-control/<a class="el" href="db_category_8php_source.html">dbCategory.php</a></li>
</ul>
</div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Data Structures</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>Variables</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>



<hr class="footer"/><address class="footer"><small>
Generated on Tue Nov 29 2011 18:18:56 for i2c by &#160;<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.7.5.1
</small></address>

</body>
</html>
